﻿--修改家庭成员及社会关系
CREATE proc [dbo].[proc_Employee_MemberRelation_Update]
(
	@MName nvarchar(50),
	@Company nvarchar(50),
	@Post  nvarchar(50),
	@Birthday NVARCHAR(20),
	@PoliticsStatus NVARCHAR(50),
	@Relation nvarchar(50),
	@id int
)
as
	update Employee_MemberRelation 
	set MName=@MName,
	Company=@Company,
	Post=@Post,
    Birthday = @Birthday,
    PoliticsStatus = @PoliticsStatus,
	Relation=@Relation 
	where id=@id